program
Table: program
The program table stores information about different programs.
It is used to manage and identify programs within the system.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| programId | int(11) | NOT NULL, PRIMARY KEY, AUTO_INCREMENT | Unique identifier for each program |
| name | varchar(100) | NOT NULL | Name of the program |
| createdDate | timestamp | NULL, DEFAULT CURRENT_TIMESTAMP | Timestamp when the program record was created |
Indexes
- PRIMARY - Primary key on
programId
Foreign Key Relations
None
Usage Notes
- This table serves as a reference for programs in the system.
programIdis used to link program-specific data in other tables.createdDatehelps track when programs are added.